SELECT ORG_MEMBER.name username,ORG_MEMBER.CODE,ORG_PRINCIPAL.LOGIN_NAME loginName,
PERSON_SECRET_LEVELS.PWD_STRENGTH secretLevel,
ORG_UNIT.CODE ou
FROM ORG_MEMBER 
LEFT JOIN ORG_UNIT ON ORG_UNIT."ID" = ORG_MEMBER.ORG_DEPARTMENT_ID
LEFT JOIN ORG_PRINCIPAL ON ORG_PRINCIPAL.MEMBER_ID = ORG_MEMBER."ID"
LEFT JOIN PERSON_MEMBER_MAP ON PERSON_MEMBER_MAP.MEMBER_ID = ORG_MEMBER."ID"
LEFT JOIN PERSON_SECRET_LEVELS ON PERSON_SECRET_LEVELS.PSL_ID = PERSON_MEMBER_MAP.PSL_ID
WHERE ORG_MEMBER.IS_DELETED = 0 AND ORG_MEMBER.IS_ENABLE = 1 AND ORG_MEMBER.ORG_DEPARTMENT_ID != -1 AND ORG_MEMBER.CODE IS NOT NULL
ORDER BY ORG_MEMBER.SORT_ID